How do you add, get, update, and delete records?

Question

Manish Sharma · Answer

We'll 
assume a database UserDB with an object store named users and
keyPath: "id".
Setup (once)
const request = indexedDB.open("UserDB", 1);
request.onupgradeneeded = function (event) {
    const db = event.target.result;
    if (!db.objectStoreNames.contains("users")) {
        db.createObjectStore("users", { keyPath: "id" });
    }
};
Add a Record
function addUser(db, user) {
    const tx = db.transaction("users", "readwrite");
    const store = tx.objectStore("users");
    store.add(user); // Must contain a unique "id"
}
Example usage:
addUser(db, { id: 1, name: "Alice", email: "alice@example.com" });
Get a Record by Key
function getUser(db, id) {
    return new Promise((resolve, reject) =andgt; {
        const tx = db.transaction("users", "readonly");
        const store = tx.objectStore("users");
        const request = store.get(id);
        request.onsuccess = () =andgt; resolve(request.result);
        request.onerror = () =andgt; reject(request.error);
    });
}
Usage:
getUser(db, 1).then(user =andgt; console.log(user));
Update a Record
You use put() instead of add() — it replaces the object with the same key:
function updateUser(db, updatedUser) {
    const tx = db.transaction("users", "readwrite");
    const store = tx.objectStore("users");
    store.put(updatedUser); // Replaces if id exists
}
Example:
updateUser(db, { id: 1, name: "Alice Smith", email: "alice@example.com" });
💡 put() will add a new record if the key doesn't exist — unlike 
add() which throws an error if the key exists.
Delete a Record
function deleteUser(db, id) {
    const tx = db.transaction("users", "readwrite");
    const store = tx.objectStore("users");
    store.delete(id);
}
Example:
deleteUser(db, 1);
Optional: Get All Records
function getAllUsers(db) {
    return new Promise((resolve, reject) =andgt; {
        const tx = db.transaction("users", "readonly");
        const store = tx.objectStore("users");
        const request = store.getAll();
        request.onsuccess = () =andgt; resolve(request.result);
        request.onerror = () =andgt; reject(request.error);
    });
}
Summary of Methods
Operation
Method
Add
store.add(data)
Get
store.get(key)
Update
store.put(data)
Delete
store.delete(key)
Get All
store.getAll()

interview

How do you add, get, update, and delete records?

Manish Sharma

Can you answer this question?

1 Answers

Setup (once)

Add a Record

Get a Record by Key

Update a Record

Delete a Record

Optional: Get All Records

Summary of Methods

Liked By

Operation	Method
Add	`store.add(data)`
Get	`store.get(key)`
Update	`store.put(data)`
Delete	`store.delete(key)`
Get All	`store.getAll()`